Google Links

Follow the links below to find material targeted to the unit's elements, performance criteria, required skills and knowledge

Elements and Performance Criteria

1. Identify database requirements
   • Determine information required from database
   • Identify tables holding this information
   • Identify primary keys in these tables
   • Identify relationships between these tables including foreign keys
2. Build and implement SQL in relational databases
   • Identify and build SQL statements according to task requirements
   • Create tables in a database using SQL statements
   • Create primary and foreign keys required in database table
   • Manipulate data in a database using SQL statements
   • Query database using SQL statements
   • Retrieve information from database using written SQL statements
3. Test and verify SQL results
   • Construct test data and test SQL statements according to organisational procedures
   • Determine expected results of SQL statements
   • Verify result of constructed SQL statements against expected results and document findings
   • Confirm task requirements are met and obtain sign-off from required personnel

Performance Evidence

The candidate must demonstrate the ability to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including evidence of the ability to:

apply structured query language (SQL) to a relational database and gather required information according to task requirements.

In the course of the above, the candidate must:

generate queries for one or more tables and provide required data

add, modify, retrieve and delete records from database tables as required test and verify SQL statements.

---

Knowledge Evidence

The candidate must be able to demonstrate knowledge to complete the tasks outlined in the elements, performance criteria and foundation skills of this unit, including knowledge of:

organisational policies and procedures relating to SQL application including:

identifying SQL requirements from job specifications

testing and verifying SQL results

features and application of primary and foreign keys in database tables, aggregate functions and clause functions required in SQL application

principles of "combining and/or condition" in SQL statements and Boolean operators

IN and BETWEEN conditional operators

mathematical operators

table joins (relationships)

documentation techniques relevant to applying structured query language in relational databases

SQL statement testing methodologies.

---